
global datapath "~/DataFolder"
global Analyses "~/Results"

********************************************************* Table 3: Approval Rate
use "$datapath/RegData.dta", clear

global controls riskiness male avg_minority branch distance numsbl lretain size loan deposit p_ci p_re roa liquid

cd "$Analyses"

reghdfe approve_rate_n spec_above5pctemp $controls , absorb(rssdhcr year fips) cluster(fips)
outreg2 using Table3.xls, replace label dec(3) drop(num) nor2 stats(coef se) addstat(Adjusted R-squared,e(r2_a)) addtext(Year FE, Yes, Bank FE, Yes, County FE, Yes, County*Year FE, No, Bank*State FE, No) 

reghdfe approve_rate_n spec_above5pctemp $controls ,absorb(county_year rssdhcr) cluster(fips)
outreg2 using Table3.xls, append label dec(3) drop(num) nor2 stats(coef se) addstat(Adjusted R-squared,e(r2_a)) addtext(Year FE, No, Bank FE, Yes, County, No, County*Year FE, Yes, Bank*State FE, No) 

reghdfe approve_rate_n spec_above5pctemp $controls ,absorb(county_year bank_state) cluster(fips)
outreg2 using Table3.xls, append label dec(3) drop(num) nor2 stats(coef se) addstat(Adjusted R-squared,e(r2_a)) addtext(Year FE, No, Bank FE, No, County, No, County*Year FE, Yes, Bank*State FE, Yes) 

reghdfe approve_rate_v spec_above5pctemp $controls , absorb(rssdhcr year fips) cluster(fips)
outreg2 using Table3.xls, append label dec(3) drop(num) nor2 stats(coef se) addstat(Adjusted R-squared,e(r2_a)) addtext(Year FE, Yes, Bank FE, Yes, County FE, Yes, County*Year FE, No, Bank*State FE, No) 

reghdfe approve_rate_v spec_above5pctemp $controls ,absorb(county_year rssdhcr) cluster(fips)
outreg2 using Table3.xls, append label dec(3) drop(num) nor2 stats(coef se) addstat(Adjusted R-squared,e(r2_a)) addtext(Year FE, No, Bank FE, Yes, County, No, County*Year FE, Yes, Bank*State FE, No) 

reghdfe approve_rate_v spec_above5pctemp $controls ,absorb(county_year bank_state) cluster(fips)
outreg2 using Table3.xls, append label dec(3) drop(num) nor2 stats(coef se) addstat(Adjusted R-squared,e(r2_a)) addtext(Year FE, No, Bank FE, No, County, No, County*Year FE, Yes, Bank*State FE, Yes) 



